A1 is a 10-digit number, ie 1234567890. Perhaps I wasn't clear enough - =text(a1;"000-000-0000") works fine (as does ="NHS: "&text(a1;"000-000-0000") for that matter) so I don't understand where I went wrong before.
The auto-reformat comment was for something else, but relating to release characters. If I write in:
I would expect to see
if \ is the release character. (This is how C++ works.)
Instead, OpenOffice rewrites my input:
Note the extra speechmark at the end. Then it gives a 509 error saying the operator's missing. I don't want Calc to decide to put an extra speechmark into my input without giving me the easy option to undo its changes.
If I omit the space between the last two " in my input,
Calc removes the last speechmark, which displays
Is there a release character allowing me to put a speechmark into the middle of text strings?
In the past I've had to do hideous things like
Code: Select all
A1: "
A2: ="This is a speechmark: "&$A$1
I use Calc as a calculator. And also as a tool for displaying the results of the calculations. I write formulas which, for instance, turn a user's shift times into a detailed breakdown of overtime, weekend, antisocial hours, and bank holiday working hours. Then I need to format the resulting numbers to print over the required timesheets. I would be interested to know if this
type of task could be done better using databases, but the suggestion appears bizarre to me.