format cell : "Z#.####" minus position issue.

[jazzaman]

Hello Everyone.

The problem concerns the cell's category, and the minus position.
These are the kind of values i put into a column :

5
1.00
-3.25
15.7584234786541
ect...

I'm trying to find a solution to get this kind of format for this column :

Z5.
Z1.
Z-3.25
Z15.7584

In other words :
- all cells must be preceeded by a "Z"
- if there is a minus sign, it must be BEHIND the Z
- the decimal separation is a point
- the point is always there, even if there is no decimal
- the maximum of decimals is 4.

I nearly had it, with this : Z#.####
(in format cells -> category -> custom -> type)

The only problem is the minus sign : it always go in front of the Z.
(for those interested, I need this for creating some G-Code for CNC milling. Z-1. indicates a position to the mill). The mill does not understand -Z1.)

The same problem could be imagined with a currency : -€1.12 or €-1.12

Any solution ?

Thanks for all help.

[romperstomper]

Close - you need:
Z#.####;Z-#.####

[jazzaman]

thanks a lot Romper, that worked great.

Have a nice day,

jazz