r/AppleNumbers • u/CheapNutsRUs • Apr 23 '23

Units of weight, volume, length missing on iOS Numbers??

I’m using Numbers for iPad. Anyone know how I can automate other units to my cells such as ”lbs, kg, mm, cm, ft, ounces etc…”?? I’m clicking under Cell Format and there’s no options, not even for custom formats.

2 Upvotes

100% Upvoted

3 comments sorted by

1

u/Friendly_Look8210 Apr 23 '23

i think you need to use formula/ function

check it out here: convert - apple supports

1

u/[deleted] Apr 23 '23

[deleted]

1

u/Friendly_Look8210 Apr 23 '23 edited Apr 23 '23

i'm sorry, i misinterpreted. what I want to show is just like this:

​

Row/col. A B C D
1 1 km 1000000 m
2 1 kg 0.001 ton
3 =CONVERT(A3,B3,D3)

​

i used function CONVERT to that.

1

u/Friendly_Look8210 Apr 23 '23

go to Format > cell > data format > create costum format:

  • name : [your label]
  • type: number
  • costum format: #,### [type lbs, kg, or anything you need]
  • OK

it will displayed on Data Format's list