Hello.
I use the
=SHAMSI()
function to insert the Solar Hijri date. The output of this function is:
14010612.
I want there to be a slash between the day, month, and year. It means to be
1401/06/12
What should I change in the format cells (Ctrl+1)?
I don’t know what SHAMSI() returns, whether it’s text or numeric; if it is numeric you can apply the format code 0000"/"00"/"00 but if it is text you can’t, you’d have to process the result like
=REGEX(SHAMSI(...);"(\d{4})(\d{2})(\d{2})";"$1/$2/$3")
Btw, where did you get the SHAMSI() function from?
1 Like
SHAMSI()
Function is an Iranian function for insert Solar Hijri date.
This function is added to Calc if you have previously added its macro to spreedsheet.
See also: tdf#149908, tdf#147660.
2 Likes
Yes, That’s it.
Interesting, did @KoJoT care to notice that they posted to English section of the Ask site?
And the “doesn’t work for me” tells absolutely nothing about specific problem - an error message or number, or incorrect output … maybe you didn’t use the correct localized function name.