Number/text formats

  • Thread starter Thread starter falcon1966
  • Start date Start date
F

falcon1966

Hello,

I need some help to get a Number format in Excelsheets.
I work with artikel numbers in the format 00.0000/0
When I try to get this format in the user formats doesn't this work
I become I this format working, example:
I type 201001 -> has be comes to 20.1001/0

thanks
 
In XL 97 with a Custom format of 00."."0000"/"0 and an entry of 2010010 I
get 20.1001/0 returned

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HDMI is a terrible format and I wish it never existed 2
Index/Match with text-looking numbers 1
Sum number range ignoring numbers formatted as text 0
format 9
Number format 8
Formatting number in Data Table 2
Formatting Cells - Hex Values 3
Date formatting 4

Back
Top